<?php

$sql = "
SELECT 
		routine_name as Name, 
		created as create_date, 
		routine_schema as dbowner, 
		routine_definition as source_code 
FROM 
		`information_schema`.`ROUTINES` 
where 
		routine_schema = '{$param['db']}' 
		and routine_type = 'PROCEDURE' 
order by 
		routine_name
";

return $sql;

?>